<?php
/**
 * Created by JetBrains PhpStorm.
 * User: pete
 * Date: 10/28/13
 * Time: 2:46 PM
 * To change this template use File | Settings | File Templates.
 */
class Faculty_Plantilla_Model extends CI_Model {
    //exp_fmis_rank


    public function __construct(){
        parent::__construct();


    }

   public function getPlantilla()
   {
       $sql = "SELECT concat(FirstName,' ',MiddleName,' ',LastName) as 'Name', exp_fmis_rank.Description, exp_fmis_rank.Salary FROM `exp_fmis_rank` INNER JOIN `exp_fmis_member_profile` ON exp_fmis_rank.ID = exp_fmis_member_profile.Rank ORDER BY Salary Desc";
       $query =  $this->db->query($sql);
       return $query->result_array();
   }

}



?>